from matplotlib import pyplot as plt
import pandas as pd

plt.rcParams['font.sans-serif']=['SimHei']
df=pd.read_excel('.\data\computer_2_old_2.xlsx')
df=df.drop(['min_salary','max_salary'],axis=1)
duplicates=df.duplicated()
df=df.drop_duplicates()
df=df.reset_index(drop=True)
df.boxplot(column='salary（罗坛）')
df.to_excel('.\data\computer_2_new.xlsx',sheet_name='sheet1')
plt.show()


